package com.sharemarking.system.mapper;

import java.util.List;
import java.util.Map;
import com.sharemarking.wa.common.entity.Member;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface MemberMapper {

	//@Select("SELECT * FROM eu_member WHERE del_flag = 0 LIMIT #{pageIndex},#{pageSize}")
	List<Member> getPage(Map<String,Object> map);

	//@Select("SELECT COUNT(*) FROM eu_member WHERE del_flag = 0")
	int getPageTotal(Map<String,Object> map);

	@Select("SELECT alias FROM sys_member WHERE id = #{memberId}")
	String getAlias(Integer memberId);
}